{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["INFO","NUTRIEN SAPI PERAH","NUTRIEN SAPI POTONG","BAHAN PAKAN","SAPI PERAH","SAPI POTONG","TRIAL & ERROR","CONTACT","BACKUP"],"not_rendered":{"charts":0,"images":15,"macros":1,"external_links":1,"defined_names":1597,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"INFO","index":0,"n_rows":31,"n_cols":3,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"FORSUM for Ruminant ver 4.0++"]
[null,null," (c) 2019 Department of Nutrition and Feed Technology - IPB University"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Instalasi FORSUM"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"FORSUM Sheet"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Cara Penggunaan FORSUM"]

{"sheet":"NUTRIEN SAPI PERAH","index":1,"n_rows":44,"n_cols":9,"rows_kept":44,"cut":false,"hidden":false,"merged":[[5,5,5,6],[5,7,5,8],[19,1,20,1],[19,2,20,2],[19,3,19,4],[19,5,19,6],[19,7,19,8],[33,1,34,1],[33,2,34,2],[33,3,33,4],[5,1,6,1],[5,2,6,2],[5,3,5,4]]}
[]
[null,"        FORSUM for Ruminant ver 4.0++"]
[null,"                  (c) 2019 Department of Nutrition and Feed Technology - IPB University"]
[]
[null,"Tabel A1. Kebutuhan Nutrien pada Sapi Perah (SNI 3148-1:2017)"]
[null,"Nutrien","Unit","Calf Starter 1",null,"Calf Starter 2",null,"Dara"]
[null,null,null,"Min","Max","Min","Max","Min","Max"]
[null,"Bahan Kering","%",86,"-",86,"-",86,"-"]
[null,"Abu","%","-",10,"-",10,"-",10]
[null,"Protein Kasar","%",21,"-",16,"-",15,"-"]
[null,"Lemak Kasar","%","-",12,"-",7,"-",7]
[null,"Serat Kasar","%","-","-","-","-","-","-"]
[null,"NDF","%","-",15,"-",20,"-",30]
[null,"TDN","%",80,"-",70,"-","70 (65)","-"]
[null,"Kalsium","%",0.7,0.9,0.6,0.8,0.6,1]
[null,"Pospor","%",0.4,0.6,0.4,0.6,0.4,0.6]
[]
[]
[null,"Tabel A2. Kebutuhan Nutrien pada Sapi Perah (SNI 3148-1:2017)"]
[null,"Nutrien","Unit","Laktasi",null,"Laktasi Prod Tinggi",null,"Kering Bunting"]
[null,null,null,"Min","Max","Min","Max","Min","Max"]
[null,"Bahan Kering","%",86,"-",86,"-",86,"-"]
[null,"Abu","%","-",10,"-",10,"-",10]
[null,"Protein Kasar","%","14 (16)","-",18,"-",16,"-"]
[null,"Lemak Kasar","%","-",7,"-",7,"-",7]
[null,"Serat Kasar","%","-","-","-","-","-","-"]
[null,"NDF","%","-",35,"-",33,"-",33]
[null,"TDN","%",68,"-","68 (70)","-",68,"-"]
[null,"Kalsium","%",0.8,1.2,0.8,1.3,0.8,1.2]
[null,"Pospor","%",0.4,0.6,0.4,0.8,0.4,0.8]
[]
[]
[null,"Tabel A3. Kebutuhan Nutrien pada Sapi Perah (SNI 3148-1:2017)"]
[null,"Nutrien","Unit","Jantan"]
[null,null,null,"Min","Max"]
[null,"Bahan Kering","%",86,"-"]
[null,"Abu","%","-",12]
[null,"Protein Kasar","%",12,"-"]
[null,"Lemak Kasar","%","-",6]
[null,"Serat Kasar","%","-","-"]
[null,"NDF","%","-",35]
[null,"TDN","%",65,"-"]
[null,"Kalsium","%",0.6,0.8]
[null,"Pospor","%",0.3,0.6]

{"sheet":"NUTRIEN SAPI POTONG","index":2,"n_rows":53,"n_cols":9,"rows_kept":53,"cut":false,"hidden":false,"merged":[[5,1,6,1],[5,2,6,2],[5,3,5,4],[5,5,5,6],[5,7,5,8],[20,7,21,7],[20,8,21,8],[20,1,21,1],[20,2,21,2],[20,3,21,3],[20,4,21,4],[20,5,21,5],[20,6,21,6]]}
[]
[null,"         FORSUM for Ruminant ver 4.0++"]
[null,"                (c) 2019 Department of Nutrition and Feed Technology - IPB University"]
[]
[null,"Tabel B1. Kebutuhan Nutrien pada Sapi Potong (SNI 3148-2:2017)"]
[null,"Nutrien","Unit","Konst Penggemukan",null,"Konsentrat Induk",null,"Konsentrat Pejantan"]
[null,null,null,"Min","Max","Min","Max","Min","Max"]
[null,"Bahan Kering","%",86,"-",86,"-",86,"-"]
[null,"Abu","%","-",12,"-",12,"-",12]
[null,"Protein Kasar","%",13,"-",12,"-",12,15]
[null,"Lemak Kasar","%","-",7,"-",6,"-",6]
[null,"Serat Kasar","%","-","-","-","-","-","-"]
[null,"NDF","%","-",35,"-",35,"-",35]
[null,"TDN","%",68,"-",65,"-",65,"-"]
[null,"Kalsium","%",0.6,1.2,0.8,1.2,0.6,0.8]
[null,"Pospor","%",0.4,0.8,0.6,0.8,0.3,0.6]
[null,"Sumber: SNI Konsentrat Sapi Potong"]
[]
[]
[null,"Tabel B2. Kebutuhan Nutrien Sapi Pertumbuhan"]
[null,"BB (kg)","PBBH (kg)","BK (kg)","Hijauan( %)","PK (%)","TDN (%)","Ca (%)","P (%)"]
[]
[null,100,0,2.1,100,8.6999999999999993,50,0.18,0.18]
[null,null,0.5,3,"70-80",12.4,55,0.47,0.37]
[null,null,0.7,2.9,"50-60",14.4,62,0.66,0.48]
[null,null,1.1000000000000001,3,15,17.8,77,0.97,0.63]
[null,150,0,2.8,100,8.6999999999999993,50,0.18,0.18]
[null,null,0.5,4.0999999999999996,"70-80",11,55,0.34,0.39]
[null,null,0.7,4,"50-60",12.4,62,0.45,0.35]
[null,null,1.1000000000000001,4,15,15,77,0.5,0.38]
[null,200,0,3.5,100,8.5,50,0.18,0.18]
[null,null,0.3,5.4,100,9.1,50,0.18,0.18]
[null,null,0.7,6,"70-80",10.199999999999999,58,0.3,0.27]
[null,null,1.1000000000000001,5,15,12.8,77,0.5,0.38]
[null,250,0,4.0999999999999996,100,8.5,50,0.18,0.18]
[null,null,0.3,6.4,100,8.9,50,0.18,0.18]
[null,null,0.7,5.8,"55-65",10.5,65,0.28999999999999998,0.26]
[null,null,1.1000000000000001,6.5,"20-25",11.4,72,0.38,0.31]
[null,300,0,4.7,100,8.6,50,0.18,0.18]
[null,null,0.3,7.4,100,8.9,50,0.18,0.18]
[null,null,0.7,6.6,"55-65",10.5,65,0.24,0.23]
[null,null,1.1000000000000001,7.5,"20-25",11.4,72,0.31,0.27]
[null,350,0,5.3,100,8.5,50,0.18,0.18]
[null,null,0.3,8.1999999999999993,100,8.5,50,0.18,0.18]
[null,null,0.7,7.9,"55-65",9.1999999999999993,62,0.19,0.19]
[null,null,1.1000000000000001,8.3000000000000007,"20-25",9.9,72,0.24,0.23]
[null,400,0,5.8,100,8.5,50,0.18,0.18]
[null,null,0.3,9.1,100,8.5,50,0.18,0.18]
[null,null,0.5,8.5,"70-80",8.8000000000000007,58,0.18,0.18]
[null,null,0.9,8.4,"20-25",9.4,69,0.2,0.2]
[null,450,0,6.4,100,8.5,50,0.18,0.18]
[null,null,0.2,8.6999999999999993,100,8.5,50,0.18,0.17]
[null,null,0.8,9.1,"35-45",9,68,0.18,0.18]

{"sheet":"BAHAN PAKAN","index":3,"n_rows":106,"n_cols":25,"rows_kept":106,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"FORSUM for Ruminant ver 4.0++"]
[null,null,null," (c) 2019 Department of Nutrition and Feed Technology - IPB University"]
[]
[null,"Tabel C1. Komposisi Nutrien Bahan Pakan"]
[null,"No",null,"Bahan Pakan","Min","Max","Harga AsFeed","Harga BK","Kadar Air","Bahan Kering","Abu","PK","LK","SK","BETN","NDF","ADF","GE","DE","TDN","Ca","P","K","Na","DM"]
[null,null,null,"== HIJAUAN =="]
[null,1,null,"Rumput gajah",null,null,230,{"$f":"G8*100/Y8","v":1284.916201117318},{"$f":"100-J8","v":82.1},17.900000000000006,13.8,9.6999999999999993,2,36.1,38.4,71.5,42.5,17.399999999999999,10.199999999999999,58,0.36,0.28999999999999998,2.9,0.03,{"$f":"100-I8","v":17.900000000000006}]
[null,2,null,"Rumput lapang",null,null,250,{"$f":"G9*100/Y9","v":1396.6480446927369},{"$f":"100-J9","v":82.1},17.900000000000006,14,10,2,37,38.4,71.5,42.5,17.399999999999999,10.199999999999999,60,0.36,0.28999999999999998,2.9,0.03,{"$f":"100-I9","v":17.900000000000006}]
[null,3,null,"Rumput BD",null,null,230,858.20895522388071,73.2,26.799999999999997,8.6,8.9,1.9,31.4,49.2,68.099999999999994,37.200000000000003,18.100000000000001,9.5,57,0.36,0.22999999999999998,1.8399999999999999,0.05,26.799999999999997]
[null,4,null,"Rumput BH",null,null,230,884.61538461538464,74,26,6.7,9,2.4,34.799999999999997,47.100000000000009,67.7,40.799999999999997,18.7,9.9,59,0.22999999999999998,0.21000000000000002,1.3699999999999999,0.35,26]
[null,5,null,"Lamtoro",null,null,350,1170.5685618729094,70.099999999999994,29.900000000000006,8.5,23.3,4,19.899999999999999,44.300000000000004,40.9,25.4,19,13.9,74.400000000000006,1.0699999999999998,0.21000000000000002,1.89,0.02,29.900000000000006]
[null,6,null,"Kaliandra",null,null,350,1002.8653295128938,65.099999999999994,34.900000000000006,6.3,20.8,2.4,25.2,45.3,55.6,37.1,19.100000000000001,13.1,71,0.71,0.27999999999999997,0.6,0.01,34.900000000000006]
[null,7,null,"Glirisidia",null,null,350,1383.3992094861662,74.7,25.299999999999997,10,22.3,4.2,19.7,43.8,49.7,34.799999999999997,19.7,14.5,72,1.19,0.22999999999999998,2.71,0.04,25.299999999999997]
[null,8,null,"Turi",null,null,350,2023.1213872832373,82.7,17.299999999999997,8.5,25.5,4.7,16.2,45.099999999999994,25.5,19.5,19.2,14.5,72,1.41,0.45999999999999996,2.04,0.24,17.299999999999997]
[null,9,null,"Angsana",null,null,350,383.77192982456137,8.7999999999999972,91.2,9.9,11.1,1.7,33.700000000000003,43.599999999999994,51.8,43.9,17.8,9.8000000000000007,70,1.1000000000000001,0.15,1.1099999999999999,0.04,91.2]
[null,10,null,"Tebon jagung",null,null,250,1072.961373390558,76.7,23.299999999999997,7,7.9,1.9,28.7,54.5,63.2,31.3,18.2,11.7,56.671874999999993,0.36,0.21,1.58,0.05,23.299999999999997]
[null,11,null,"Silase jagung",null,null,300,1276.5957446808511,76.5,23.5,4.8,8,2.6,23.6,61,49.3,27,18.899999999999999,12.8,62,0.21000000000000002,0.19,1.3900000000000001,0.02,23.5]
[null,12,null,"Tanaman sorgum",null,null,250,889.67971530249133,71.900000000000006,28.099999999999994,9.1,8.1999999999999993,1.9,33.6,47.2,57.9,35,18.100000000000001,10.9,60,0.41,0.2,1.9300000000000002,0.25,28.099999999999994]
[null,13,null,"Jerami padi",null,null,150,161.63793103448276,7.2000000000000028,92.8,18.100000000000001,4.2,1.4,35.1,41.2,69.099999999999994,42.4,15.5,7.2,47,0.28999999999999998,0.09,1.8,0.27,92.8]
[null,14,null,"Sekam padi",null,null,140,152.33949945593034,8.0999999999999943,91.9,17.5,3.7,1.5,42.6,34.700000000000003,67.8,51.7,16.3,3.7,40,0.09,0.11000000000000001,0.4,0.03,91.9]
[null,15,null,"Daun singkong",null,null,350,1555.5555555555557,77.5,22.5,7.4,24.9,6.8,17.7,43.2,42.3,27.2,19.899999999999999,12.4,61.8,1.19,0.37,1.25,0.06,22.5]
[null,16,null,"Daun ubi jalar",null,null,350,2692.3076923076924,87,13,11.2,16.5,4.8,21.1,46.4,42.7,31.7,18.3,11.403015075376885,60,0.95,0.28999999999999998,2.4899999999999998,0.08,13]
[null,17,null,"Daun kol",null,null,100,114.94252873563218,13,87,11.8,21.5,3.33,12.9,50.5,0,0,0,0,69.8,0.59799999999999998,0.72199999999999998,0,0,87]
[null,18,null,"Daun kacang tanah",null,null,100,438.59649122807025,77.2,22.799999999999997,9.18,13.8,4.49,25.2,46.9,0,0,0,0,59.6,1.68,0.27300000000000002,0,0,22.799999999999997]
[null,19,null,"Daun pisang",null,null,100,429.18454935622321,76.7,23.299999999999997,11.8,16.600000000000001,5.2,23,43.4,0,0,0,0,73.5,0.56699999999999995,0.18,0,0,23.299999999999997]
[null,20,null,"Batang pisang",null,null,100,1338.6880856760376,92.53,7.4699999999999989,18.3,6.1,2.17,26.8,46.9,0,0,0,0,53.4,1.06,0.12,0,0,7.4699999999999989]
[null,21,null,"Kulit pisang",null,null,200,653.59477124183013,69.400000000000006,30.599999999999994,3.93,6.65,1.3,6.42,81.8,0,0,0,0,73.099999999999994,0.32800000000000001,0.21299999999999999,0,0,30.599999999999994]
[null,22,null,"Kulit kakao",null,null,1500,1693.0022573363433,11.400000000000006,88.6,9.3000000000000007,17.8,5.9,20.7,46.3,46.5,36.799999999999997,18.8,6.7,57,0.37,0.44000000000000006,2.68,0.02,88.6]
[null,23,null,"Kulit kacang",null,null,350,382.09606986899564,8.4000000000000057,91.6,5.2,7,2,65.900000000000006,19.899999999999991,66.400000000000006,56.4,19.8,3.4,48,0.24,6.9999999999999993E-2,0.69000000000000006,0.01,91.6]
[null,24,null,"Pod buah kakao",null,null,500,549.45054945054949,9,91,11.2,7.7,2.7,29.3,49.1,55.2,43.5,17.399999999999999,6,55,0.57000000000000006,0.33999999999999997,5.01,0.01,91]
[null,25,null,"Pelepah sawit",null,null,200,505.05050505050502,60.4,39.6,5.4,6.5,2,38.9,47.2,70.400000000000006,49.3,16.7,5,45,0.53,0.11000000000000001,0.7,0.05,39.6]
[null,26,null,"Serat sawit",null,null,220,263.15789473684214,16.400000000000006,83.6,6.7,6.2,26.5,31,29.599999999999994,66,42.8,23.5,4.5,43,0.32,0.36,0.49000000000000005,0.19,83.6]
[null,27,null,"Bagas tebu",null,null,200,434.78260869565219,54,46,5.9,1.8,0.6,45.9,45.8,86.9,58.4,18.399999999999999,7,45,0.13999999999999999,0.06,0.13,0.01,46]
[null,28,null,"Limbah nanas",null,null,230,259.59367945823931,11.400000000000006,88.6,8.1,4.5,1.2,17.8,68.400000000000006,41.8,20.9,17,8,57,0.49000000000000005,0.13,2.13,0.02,88.6]
[]
[null,null,null,"== BAHAN KONSENTRAT =="]
[null,1,null,"Jagung",null,null,4500,{"$f":"G38*100/Y38","v":5214.3684820393973},{"$f":"100-J38","v":13.700000000000003},86.3,1.4,9.4,4.3,2.5,82.4,12.2,3,18.7,12,80.8,0.05,0.3,0.39,0,{"$f":"100-I38","v":86.3}]
[null,2,null,"Dedak padi",null,null,2800,3104.2128603104211,9.7999999999999972,90.2,12.4,10,14.4,16.3,44.2,34.4,19.600000000000001,20.2,10,67.900000000000006,6.9999999999999993E-2,1.3800000000000001,1.23,0.02,90.2]
[null,3,null,"Dedak padi kasar",null,null,2300,2578.4753363228697,10.799999999999997,89.2,16.899999999999999,8.36,3.97,28.9,41.9,0,0,0,0,50,0.13700000000000001,0.80200000000000005,0,0,89.2]
[null,4,null,"Dedak jagung",null,null,2600,2961.2756264236905,12.200000000000003,87.8,3.5,10,7.78,4.5199999999999996,74.2,0,0,0,0,82.3,0.05,0.3,0,0,87.8]
[null,5,null,"Pollard",null,null,3600,4137.9310344827591,13,87,5.6,17.3,3.9,10.4,62.800000000000004,45.2,13.4,18.899999999999999,11,69.2,0.13999999999999999,1.1099999999999999,1.3699999999999999,0.01,87]
[null,6,null,"Onggok kering",null,null,2400,3007.5187969924814,20.200000000000003,79.8,2.4,1.87,0.32400000000000001,8.9,85.5,0,0,0,0,78.3,0.2,0.1,0,0,79.8]
[null,7,null,"Gaplek",null,null,3000,3773.5849056603774,20.5,79.5,4.6900000000000004,2.6,0.7,5.67,66.3,0,0,0,0,78.5,0.17,0.09,0,0,79.5]
[null,8,null,"Singkong",null,null,3000,7978.7234042553191,62.4,37.6,2.8,2.6,0.8,3.7,90.1,7.8,5.3,17.100000000000001,14.5,81.8,0.16,0.12,0.77,0,37.6]
[null,9,null,"Ubi jalar",null,null,3100,10333.333333333334,70,30,3.6,5.5,1.1000000000000001,3.8,86,11.3,5.2,17.399999999999999,12,75,0.12,0.15,1.22,0.02,30]
[null,10,null,"Gandum",null,null,4600,5287.35632183908,13,87,1.8,12.6,1.7,2.6,81.3,13.9,3.6,18.2,13,68,6.9999999999999993E-2,0.36,0.45999999999999996,0,87]
[null,11,null,"Shorgum",null,null,4300,4919.9084668192218,12.599999999999994,87.4,2.1,10.8,3.4,2.8,80.900000000000006,11,4.3,18.8,13,68,0.03,0.32999999999999996,0.43,0.02,87.4]
[null,12,null,"Roti bekas",null,null,2800,3087.1003307607498,9.2999999999999972,90.7,0.5,12.4,1.3,0.8,85,5.5,2.8,19.100000000000001,14,76,0.1,0.62,0.82,0.97399999999999998,90.7]
[null,13,null,"Molases",null,null,3500,4794.5205479452052,27,73,14.6,5.5,1,0.1,78.8,0.8,0.5,14.7,11.3,70.7,0.91999999999999993,6.9999999999999993E-2,5.0999999999999996,0.24,73]
[null,14,null,"CGM",null,null,6500,7361.2684031710078,11.700000000000003,88.3,6.9,21.7,3.4,8.3000000000000007,59.7,39.6,10.6,18.8,13,78.5,0.03,0.4,0.1,0.08,88.3]
[null,15,null,"DDGS",null,null,3000,3374.5781777277839,11.099999999999994,88.9,5.9,30.2,10.9,8.8000000000000007,{"$f":"100-(SUM(K52:N52))","v":44.2},0,0,0,0,70,0,0,0,0,88.9]
[null,16,null,"Bungkil kedelai",null,null,7000,7963.5949943117175,12.099999999999994,87.9,7.1,51.8,2,6.7,32.400000000000006,13.7,8.3000000000000007,19.7,18.2,83.2,0.39,0.69000000000000006,2.37,0.01,87.9]
[null,17,null,"Bungkil kelapa",null,null,3100,3452.1158129175947,10.200000000000003,89.8,7,23.5,2.8,16.8,49.900000000000006,56.4,30.7,18.7,14.5,78.7,6.9999999999999993E-2,0.65,2.2800000000000002,0.06,89.8]
[null,18,null,"Bungkil inti sawit",null,null,2900,3190.3190319031901,9.0999999999999943,90.9,4.5999999999999996,18.7,2.8,20.2,53.7,73.2,45,18.8,13.3,79,0.27,0.65999999999999992,0.74,0,90.9]
[null,19,null,"Bungkil inti sawit 2#",null,null,2750,3015.3508771929824,8.7999999999999972,91.2,4.7,16.7,9.1999999999999993,19.8,49.6,73,44.8,20.100000000000001,14.3,78,0.27999999999999997,0.6,0.65,0.02,91.2]
[null,20,null,"Bungkil kacang tanah",null,null,6700,7411.5044247787609,9.5999999999999943,90.4,2.4,53.3,2.1,7.1,35.100000000000009,16.7,10,20,16.899999999999999,80.900000000000006,0.18,0.69000000000000006,1.3900000000000001,0.01,90.4]
[null,21,null,"Bungkil biji kapas",null,null,3500,3850.38503850385,9.0999999999999943,90.9,7.4,47.3,3,12.9,29.400000000000006,27,17.8,20,12,73.7,0.21000000000000002,1.31,1.64,0.09,90.9]
[null,22,null,"Bungkil bii kapuk",null,null,3500,3910.6145251396647,10.5,89.5,7.9,34.1,8.1,17.7,32.200000000000003,51.8,42.5,20.399999999999999,11,72,0.49000000000000005,0.95,1.81,0,89.5]
[null,23,null,"Kulit kopi",null,null,1200,1714.2857142857142,30,70,11.28,9.94,1.97,18.170000000000002,58.6,0,0,0,0,50.6,0.68,0.2,0,0,70]
[null,24,null,"Ampas bir kering",null,null,2700,2854.1226215644824,5.4000000000000057,94.6,4.5,32,10.199999999999999,17.3,35.700000000000003,0,0,0,0,75.400000000000006,0.20499999999999999,0.55500000000000005,0,0,94.6]
[null,25,null,"Ampas kecap",null,null,2500,9398.4962406015056,73.400000000000006,26.599999999999994,14.2,23.5,24.2,16,22.1,0,0,0,0,87.2,0.88200000000000001,0.14099999999999999,0,0,26.599999999999994]
[null,26,null,"Ampas tahu basah",null,null,1500,10273.97260273973,85.4,14.599999999999994,5.0999999999999996,30.3,9.9,22.2,32.5,0,0,0,0,77.900000000000006,6.9999999999999993E-2,0.36,0,0,14.599999999999994]
[null,27,null,"Tumpi jagung",null,null,2000,2272.7272727272725,12,88,9.14,8.0399999999999991,2.44,11.7,{"$f":"100-SUM(K64:N64)","v":68.680000000000007},0,0,0,0,51.16,0.26,0.16,0,0,88]
[null,28,null,"Tongkol jagung",null,null,500,4901.9607843137237,89.8,10.200000000000003,1.55,2.52,0.8,24.5,36.51,0,0,0,0,52,0,0,0,0,10.200000000000003]
[null,29,null,"Manur ayam",null,null,600,684.93150684931516,12.400000000000006,87.6,17.399999999999999,24.2,2.4,18.5,37.500000000000007,43.8,25.9,16.8,11.6,58,5.04,1.98,1.61,0.59000000000000008,87.6]
[]
[null,null,null,"== BAHAN MINERAL =="]
[null,1,null,"Garam",null,null,2000,{"$f":"G69*100/Y69","v":2105.2631578947367},{"$f":"100-J69","v":5},95,99,0,0,0,0,0,0,0,0,0,0,0,60.6,39.4,{"$f":"100-I69","v":95}]
[null,2,null,"Kapur",null,null,1500,1578.9473684210527,5,95,99,0,0,0,0,0,0,0,0,0,36,0,0,0,95]
[null,3,null,"Tepung batu",null,null,1500,1578.9473684210527,5,95,99,0,0,0,0,0,0,0,0,0,35,0,0,0,95]
[null,4,null,"Calsium Karbonat",null,null,2000,2105.2631578947367,5,95,99,0,0,0,0,0,0,0,0,0,40,0,0,0,95]
[null,5,null,"DCP",null,null,10000,10526.315789473685,5,95,99,0,0,0,0,0,0,0,0,0,23,17,0,0,95]
[null,6,null,"Mineral Mix",null,null,30000,31578.947368421053,5,95,99,0,0,0,0,0,0,0,0,0,20,10,0,0,95]
[null,7,null,"Cattle Mix",null,null,40000,42105.26315789474,5,95,88,0,0,0,0,0,0,0,0,0,20,10,0,0,95]
[null,8,null,"Premix",null,null,80000,84210.526315789481,5,95,88,0,0,0,0,0,0,0,0,0,2,5,0,0,95]
[null,9,null,"-",null,null,9999999999,9999999999,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100]
[]
[null,null,null,"== BAHAN PAKAN LAINNYA"]
[null,1,null,"-",null,null,9999999999,9999999999,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100]
[null,2,null,"-",null,null,9999999999,9999999999,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100]
[null,3,null,"-",null,null,9999999999,9999999999,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100]
[null,4,null,"-",null,null,9999999999,9999999999,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100]
[null,5,null,"-",null,null,9999999999,9999999999,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100]
[null,6,null,"-",null,null,9999999999,9999999999,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100]
[null,7,null,"-",null,null,9999999999,9999999999,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100]
[null,8,null,"-",null,null,9999999999,9999999999,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100]
[null,9,null,"-",null,null,9999999999,9999999999,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100]
[null,10,null,"-",null,null,9999999999,9999999999,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100]
[null,11,null,"-",null,null,9999999999,9999999999,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100]
[null,12,null,"-",null,null,9999999999,9999999999,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100]
[null,13,null,"-",null,null,9999999999,9999999999,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100]
[null,14,null,"-",null,null,9999999999,9999999999,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100]
[null,15,null,"-",null,null,9999999999,9999999999,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100]
[null,16,null,"-",null,null,9999999999,9999999999,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100]
[null,17,null,"-",null,null,9999999999,9999999999,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100]
[null,18,null,"-",null,null,9999999999,9999999999,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100]
[null,19,null,"-",null,null,9999999999,9999999999,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100]
[null,20,null,"-",null,null,9999999999,9999999999,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100]
[null,21,null,"-",null,null,9999999999,9999999999,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100]
[null,22,null,"-",null,null,9999999999,9999999999,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100]
[null,23,null,"-",null,null,9999999999,9999999999,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100]
[null,24,null,"-",null,null,9999999999,9999999999,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100]
[null,25,null,"-",null,null,9999999999,9999999999,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100]
[null,26,null,"-",null,null,9999999999,9999999999,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100]
[null,null,null,"BAHAN PAKAN"]

{"sheet":"SAPI PERAH","index":4,"n_rows":26,"n_cols":55,"rows_kept":26,"cut":false,"hidden":false,"merged":[[4,15,4,23],[23,15,24,15],[24,21,24,23],[25,1,25,13]]}
[]
[null,null,null,"FORSUM for Ruminant ver 4.0++"]
[null,null,null," (c) 2019 Department of Nutrition and Feed Technology - IPB University",null,null,null,null,null,null,null,null,null,null,null,"Nama Ransum",":","Konsentrat Sapi Perah Laktasi"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Formulator",":","Idat G. Permana"]
[null,"Tabel 1. Komposisi Ransum (Least Cost Ration)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Tabel 2. Kandungan Nutrien Ransum (% DM)",null,null,null,null,null,null,null,null,null,null,"Tabel 3. Perhitungan Ransum (Jangan Dihapus)"]
[" ","No",null,"Bahan Pakan",null,"Harga",null,"Min",null,"%BK",null,"%AsFeed",null,"Max",null,"Nutrien",null,"Unit",null,"Min",null,"Nutrien",null,"Max",null,null,"No","Ingredient","Harga BK","KA","Abu","PK","LK","SK","BETN","NDF","ADF","GE","DE","TDN","Ca","P","K","Na","BK","Bahan Pakan","Min","Komposisi Ransum","Max","Nutrien","Min","Nutrient","Max","%AsFeed","%AsFeed"]
[]
[null,1,null,"Jagung",null,{"$f":"_xlfn.IFNA(VLOOKUP($D8,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":4500},null,5,null,5.0000000000000053,null,{"$f":"BB8/($BB$24/100)","v":3.7391556250110058},null,null,null,"Kadar Air",null,"%",null,null,null,{"$f":"AZ8","v":22.357642624508706},null,null,null,null,1,{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"Jagung"},{"$f":"IF(F8>0,F8*100/AS8,99999999)","v":5214.3684820393973},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":13.700000000000003},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":1.4},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":9.4},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":4.3},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":2.5},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":82.4},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":12.2},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":3},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":18.7},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":12},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":80.8},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0.05},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":0.3},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":0.39},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":86.3},{"$f":"AB8","v":"Jagung"},{"$f":"IF(H8>0,H8,0)","v":5},{"$f":"J8","v":5.0000000000000053},{"$f":"IF(N8>0,N8,100)","v":100},{"$f":"P8","v":"Kadar Air"},{"$f":"IF(T8>0,T8,0)","v":0},{"$f":"SUMPRODUCT(KadarAir,KomposisiRansum)/100","v":22.357642624508706},{"$f":"IF(X8>0,X8,100)","v":100},{"$f":"IFERROR(BC8,0)","v":5.7937427578215592},{"$f":"100/AS8*J8","v":5.7937427578215592}]
[null,2,null,"Dedak padi",null,{"$f":"_xlfn.IFNA(VLOOKUP($D9,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":2800},null,null,null,0,null,{"$f":"BB9/($BB$24/100)","v":0},null,15,null,"Abu",null,"%",null,null,null,{"$f":"AZ9","v":9.7955063949674255},null,10,null,null,2,{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"Dedak padi"},{"$f":"IF(F9>0,F9*100/AS9,99999999)","v":3104.2128603104211},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":9.7999999999999972},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":12.4},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":10},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":14.4},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":16.3},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":44.2},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":34.4},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":19.600000000000001},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":20.2},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":10},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":67.900000000000006},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":6.9999999999999993E-2},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":1.3800000000000001},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":1.23},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0.02},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":90.2},"Dedak padi",{"$f":"IF(H9>0,H9,0)","v":0},{"$f":"J9","v":0},{"$f":"IF(N9>0,N9,100)","v":15},{"$f":"P9","v":"Abu"},{"$f":"IF(T9>0,T9,0)","v":0},{"$f":"SUMPRODUCT(Abu,KomposisiRansum)/100","v":9.7955063949674255},{"$f":"IF(X9>0,X9,100)","v":10},{"$f":"IFERROR(BC9,0)","v":0},{"$f":"100/AS9*J9","v":0}]
[null,3,null,"Pollard",null,{"$f":"_xlfn.IFNA(VLOOKUP($D10,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":3600},null,null,null,29.434850300236882,null,21.835186776941082,null,null,null,"Protein Kasar",null,"%",null,17,null,17.000000000000004,null,null,null,null,3,{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"Pollard"},4137.9310344827591,{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":13},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":5.6},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":17.3},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":3.9},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":10.4},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":62.800000000000004},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":45.2},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":13.4},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":18.899999999999999},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":11},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":69.2},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0.13999999999999999},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":1.1099999999999999},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":1.3699999999999999},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0.01},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":87},"Pollard",0,29.434850300236882,100,"Protein Kasar",17,{"$f":"SUMPRODUCT(PK,KomposisiRansum)/100","v":17.000000000000004},100,33.83316126464009,33.83316126464009]
[null,4,null,"Onggok kering",null,{"$f":"_xlfn.IFNA(VLOOKUP($D11,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":2400},null,null,null,7.9838807710186011,null,6.4569211617149112,null,null,null,"Lemak Kasar",null,"%",null,null,null,6.0636619345747018,null,7,null,null,4,{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"Onggok kering"},3007.5187969924814,{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":20.200000000000003},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":2.4},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":1.87},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":0.32400000000000001},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":8.9},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":85.5},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":78.3},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0.2},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":0.1},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":79.8},"Onggok kering",0,7.9838807710186011,100,"Lemak Kasar",0,{"$f":"SUMPRODUCT(LK,KomposisiRansum)/100","v":6.0636619345747018},7,10.004863121577195,10.004863121577195]
[null,5,null,"Bungkil kelapa",null,{"$f":"_xlfn.IFNA(VLOOKUP($D12,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":3100},null,null,null,20,null,14.373680643138059,null,20,null,"Serat Kasar",null,"%",null,null,null,13.269761579711076,null,null,null,null,5,{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"Bungkil kelapa"},3452.1158129175947,{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":10.200000000000003},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":7},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":23.5},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":2.8},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":16.8},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":49.900000000000006},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":56.4},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":30.7},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":18.7},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":14.5},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":78.7},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":6.9999999999999993E-2},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":0.65},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":2.2800000000000002},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0.06},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":89.8},"Bungkil kelapa",0,20,20,"Serat Kasar",0,{"$f":"SUMPRODUCT(SK,KomposisiRansum)/100","v":13.269761579711076},100,22.271714922048996,22.271714922048996]
[null,6,null,"Bungkil inti sawit",null,{"$f":"_xlfn.IFNA(VLOOKUP($D13,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":2900},null,null,null,13.382722188499239,null,9.5015599249860543,null,15,null,"BETN",null,"%",null,null,null,53.758385560677262,null,null,null,null,6,{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"Bungkil inti sawit"},3190.3190319031901,{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":9.0999999999999943},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":4.5999999999999996},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":18.7},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":2.8},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":20.2},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":53.7},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":73.2},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":45},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":18.8},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":13.3},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":79},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0.27},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":0.65999999999999992},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":0.74},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":90.9},"Bungkil inti sawit",0,13.382722188499239,15,"BETN",0,{"$f":"SUMPRODUCT(BETN,KomposisiRansum)/100","v":53.758385560677262},100,14.722466654014562,14.722466654014562]
[null,7,null,"Ampas kecap",null,{"$f":"_xlfn.IFNA(VLOOKUP($D14,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":2500},null,null,null,15,null,36.393510951704833,null,15,null,"NDF",null,"%",null,null,null,35.000000000000021,null,35,null,null,7,{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"Ampas kecap"},9398.4962406015056,{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":73.400000000000006},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":14.2},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":23.5},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":24.2},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":16},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":22.1},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":87.2},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0.88200000000000001},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":0.14099999999999999},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":26.599999999999994},"Ampas kecap",0,15,15,"NDF",0,{"$f":"SUMPRODUCT(NDF,KomposisiRansum)/100","v":35.000000000000021},35,56.390977443609039,56.390977443609039]
[null,8,null,"Kulit kopi",null,{"$f":"_xlfn.IFNA(VLOOKUP($D15,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":1200},null,null,null,5,null,4.6098447205492779,null,5,null,"ADF",null,"%",null,null,null,16.262304314001092,null,null,null,null,8,{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"Kulit kopi"},1714.2857142857142,{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":30},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":11.28},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":9.94},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":1.97},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":18.170000000000002},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":58.6},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":50.6},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0.68},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":0.2},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":70},"Kulit kopi",0,5,5,"ADF",0,{"$f":"SUMPRODUCT(ADF,KomposisiRansum)/100","v":16.262304314001092},100,7.1428571428571432,7.1428571428571432]
[null,9,null,"Kulit kacang",null,{"$f":"_xlfn.IFNA(VLOOKUP($D16,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":350},null,null,null,0,null,0,null,5,null,"GE",null,"MJ/kg",null,null,null,12.924934513156581,null,null,null,null,9,{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"Kulit kacang"},382.09606986899564,{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":8.4000000000000057},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":5.2},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":7},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":2},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":65.900000000000006},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":19.899999999999991},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":66.400000000000006},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":56.4},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":19.8},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":3.4},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":48},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0.24},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":6.9999999999999993E-2},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":0.69000000000000006},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0.01},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":91.6},"Kulit kacang",0,0,5,"GE",0,{"$f":"SUMPRODUCT(GE,KomposisiRansum)/100","v":12.924934513156581},100,0,0]
[null,10,null,"Molases",null,{"$f":"_xlfn.IFNA(VLOOKUP($D17,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":3500},null,null,null,1.1618777889384591,null,1.0271926942145195,null,null,null,"DE",null,"MJ/kg",null,null,null,8.6490277742465018,null,null,null,null,10,{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"Molases"},4794.5205479452052,{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":27},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":14.6},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":5.5},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":1},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":0.1},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":78.8},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":0.8},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":0.5},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":14.7},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":11.3},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":70.7},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0.91999999999999993},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":6.9999999999999993E-2},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":5.0999999999999996},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0.24},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":73},"Molases",0,1.1618777889384591,100,"DE",0,{"$f":"SUMPRODUCT(DE,KomposisiRansum)/100","v":8.6490277742465018},100,1.5916134095047383,1.5916134095047383]
[null,11,null,"Garam",null,{"$f":"_xlfn.IFNA(VLOOKUP($D18,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":2000},null,0.5,null,0.5,null,0.3396727688825783,null,0.5,null,"TDN",null,"%",null,68,null,73.404093177165379,null,null,null,null,11,{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"Garam"},2105.2631578947367,{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":5},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":99},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":60.6},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":39.4},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":95},"Garam",0.5,0.5,0.5,"TDN",68,{"$f":"SUMPRODUCT(TDN,KomposisiRansum)/100","v":73.404093177165379},100,0.52631578947368418,0.52631578947368418]
[null,12,null,"Kapur",null,{"$f":"_xlfn.IFNA(VLOOKUP($D19,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":1500},null,null,null,2.5366689513068019,null,1.7232747328576954,null,null,null,"Kalsium",null,"%",null,0.8,null,1.1999999999999993,null,1.2,null,null,12,{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"Kapur"},1578.9473684210527,{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":5},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":99},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":36},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":95},"Kapur",0,2.5366689513068019,100,"Kalsium",0.8,{"$f":"SUMPRODUCT(Ca,KomposisiRansum)/100","v":1.1999999999999993},1.2,2.6701778434808441,2.6701778434808441]
[null,13,null,"DCP",null,{"$f":"_xlfn.IFNA(VLOOKUP($D20,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":10000},null,null,null,0,null,0,null,null,null,"Phosphor",null,"%",null,0.4,null,0.6,null,0.6,null,null,13,{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"DCP"},10526.315789473685,{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":5},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":99},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":23},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":17},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":95},"DCP",0,0,100,"Phosphor",0.4,{"$f":"SUMPRODUCT(P,KomposisiRansum)/100","v":0.6},0.6,0,0]
[null,14,null,"-",null,{"$f":"_xlfn.IFNA(VLOOKUP($D21,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":9999999999},null,null,null,0,null,0,null,null,null,"Kalium",null,"%",null,null,null,1.3400453605440015,null,null,null,null,14,{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"-"},9999999999,{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":100},"-",0,0,100,"Kalium",0,{"$f":"SUMPRODUCT(K,KomposisiRansum)/100","v":1.3400453605440015},100,0,0]
[null,15,null,"-",null,{"$f":"_xlfn.IFNA(VLOOKUP($D22,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":9999999999},null,null,null,0,null,0,null,null,null,"Natrium",null,"%",null,null,null,0.21473199172347598,null,null,null,null,15,{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"-"},9999999999,{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":100},"-",0,0,100,"Natrium",0,{"$f":"SUMPRODUCT(Na,KomposisiRansum)/100","v":0.21473199172347598},100,0,0]
[]
[null,null,null,"Harga Ransum (Rp/kg BK)",null,{"$f":"IF(HargaRansum<10000,HargaRansum,\"Ërror\")","v":4437.9778146756717},null,null,null,{"$f":"SUM(KomposisiRansum)","v":100},null,{"$f":"(SUM(L8:L22))","v":100},null,null,null,"Click to formulate >>",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(KomposisiRansum*Harga)/100","v":4437.9778146756717},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(SUM(BB8:BB22))","v":154.94789034902783},{"$f":"(SUM(BC8:BC22))","v":154.94789034902783}]
[null,null,null,"Harga Ransum (Rp/kg segar)",null,{"$f":"SUMPRODUCT(L8:L22,F8:F22)/100","v":2864.1744038456459},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2019-09-03T19:07:03.740"}]
[null," (c) 2019 Department of Nutrition and Feed Technology - IPB University"]

{"sheet":"SAPI POTONG","index":5,"n_rows":26,"n_cols":55,"rows_kept":26,"cut":false,"hidden":false,"merged":[[4,15,4,23],[23,15,24,15],[24,21,24,23],[25,1,25,13]]}
[]
[null,null,null,"FORSUM for Ruminant ver 4.0++"]
[null,null,null," (c) 2019 Department of Nutrition and Feed Technology - IPB University",null,null,null,null,null,null,null,null,null,null,null,"Nama Ransum",":","Konsentrat Sapi Potong"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Formulator",":","Idat G. Permana"]
[null,"Tabel 1. Komposisi Ransum (Least Cost Ration)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Tabel 2. Kandungan Nutrien Ransum (% DM)",null,null,null,null,null,null,null,null,null,null,"Tabel 3. Perhitungan Ransum (Jangan Dihapus)"]
[" ","No",null,"Bahan Pakan",null,"Harga",null,"Min",null,"%BK",null,"%AsFeed",null,"Max",null,"Nutrien",null,"Unit",null,"Min",null,"Nutrien",null,"Max",null,null,"No","Ingredient","Harga BK","KA","Abu","PK","LK","SK","BETN","NDF","ADF","GE","DE","TDN","Ca","P","K","Na","BK","Bahan Pakan","Min","Komposisi Ransum","Max","Nutrien","Min","Nutrient","Max","%AsFeed","%AsFeed"]
[]
[null,1,null,"Jagung",null,{"$f":"_xlfn.IFNA(VLOOKUP($D8,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":4500},null,5,null,5.0000000000000178,null,{"$f":"BB8/($BB$24/100)","v":4.9952953168796768},null,null,null,"Kadar Air",null,"%",null,null,null,{"$f":"AZ8","v":13.393442769954639},null,null,null,null,1,{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"Jagung"},{"$f":"IF(F8>0,F8*100/AS8,99999999)","v":5214.3684820393973},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":13.700000000000003},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":1.4},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":9.4},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":4.3},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":2.5},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":82.4},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":12.2},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":3},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":18.7},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":12},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":80.8},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0.05},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":0.3},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":0.39},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":86.3},{"$f":"AB8","v":"Jagung"},{"$f":"IF(H8>0,H8,0)","v":5},{"$f":"J8","v":5.0000000000000178},{"$f":"IF(N8>0,N8,100)","v":100},{"$f":"P8","v":"Kadar Air"},{"$f":"IF(T8>0,T8,0)","v":0},{"$f":"SUMPRODUCT(KadarAir,KomposisiRansum)/100","v":13.393442769954639},{"$f":"IF(X8>0,X8,100)","v":100},{"$f":"IFERROR(BC8,0)","v":5.7937427578215734},{"$f":"100/AS8*J8","v":5.7937427578215734}]
[null,2,null,"Dedak padi",null,{"$f":"_xlfn.IFNA(VLOOKUP($D9,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":2800},null,null,null,15,null,{"$f":"BB9/($BB$24/100)","v":14.337937445012679},null,15,null,"Abu",null,"%",null,null,null,{"$f":"AZ9","v":9.5380122072982108},null,12,null,null,2,{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"Dedak padi"},{"$f":"IF(F9>0,F9*100/AS9,99999999)","v":3104.2128603104211},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":9.7999999999999972},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":12.4},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":10},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":14.4},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":16.3},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":44.2},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":34.4},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":19.600000000000001},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":20.2},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":10},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":67.900000000000006},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":6.9999999999999993E-2},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":1.3800000000000001},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":1.23},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0.02},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":90.2},"Dedak padi",{"$f":"IF(H9>0,H9,0)","v":0},{"$f":"J9","v":15},{"$f":"IF(N9>0,N9,100)","v":15},{"$f":"P9","v":"Abu"},{"$f":"IF(T9>0,T9,0)","v":0},{"$f":"SUMPRODUCT(Abu,KomposisiRansum)/100","v":9.5380122072982108},{"$f":"IF(X9>0,X9,100)","v":12},{"$f":"IFERROR(BC9,0)","v":16.62971175166297},{"$f":"100/AS9*J9","v":16.62971175166297}]
[null,3,null,"Pollard",null,{"$f":"_xlfn.IFNA(VLOOKUP($D10,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":3600},null,null,null,24.772218855172945,null,24.549780608146303,null,null,null,"Protein Kasar",null,"%",null,13,null,13.000000000000005,null,null,null,null,3,{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"Pollard"},4137.9310344827591,{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":13},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":5.6},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":17.3},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":3.9},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":10.4},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":62.800000000000004},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":45.2},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":13.4},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":18.899999999999999},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":11},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":69.2},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0.13999999999999999},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":1.1099999999999999},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":1.3699999999999999},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0.01},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":87},"Pollard",0,24.772218855172945,100,"Protein Kasar",13,{"$f":"SUMPRODUCT(PK,KomposisiRansum)/100","v":13.000000000000005},100,28.473814776060856,28.473814776060856]
[null,4,null,"Onggok kering",null,{"$f":"_xlfn.IFNA(VLOOKUP($D11,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":2400},null,null,null,17.134093069383923,null,18.512291917667376,null,null,null,"Lemak Kasar",null,"%",null,null,null,4.2864462949415385,null,7,null,null,4,{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"Onggok kering"},3007.5187969924814,{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":20.200000000000003},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":2.4},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":1.87},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":0.32400000000000001},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":8.9},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":85.5},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":78.3},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0.2},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":0.1},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":79.8},"Onggok kering",0,17.134093069383923,100,"Lemak Kasar",0,{"$f":"SUMPRODUCT(LK,KomposisiRansum)/100","v":4.2864462949415385},7,21.471294573162812,21.471294573162812]
[null,5,null,"Bungkil kelapa",null,{"$f":"_xlfn.IFNA(VLOOKUP($D12,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":3100},null,null,null,20,null,19.202404714775703,null,20,null,"Serat Kasar",null,"%",null,null,null,15.182091122866289,null,null,null,null,5,{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"Bungkil kelapa"},3452.1158129175947,{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":10.200000000000003},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":7},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":23.5},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":2.8},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":16.8},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":49.900000000000006},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":56.4},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":30.7},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":18.7},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":14.5},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":78.7},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":6.9999999999999993E-2},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":0.65},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":2.2800000000000002},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0.06},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":89.8},"Bungkil kelapa",0,20,20,"Serat Kasar",0,{"$f":"SUMPRODUCT(SK,KomposisiRansum)/100","v":15.182091122866289},100,22.271714922048996,22.271714922048996]
[null,6,null,"Bungkil inti sawit",null,{"$f":"_xlfn.IFNA(VLOOKUP($D13,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":2900},null,null,null,4.689832073035312,null,4.4483133142278382,null,20,null,"BETN",null,"%",null,null,null,57.380042838591841,null,null,null,null,6,{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"Bungkil inti sawit"},3190.3190319031901,{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":9.0999999999999943},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":4.5999999999999996},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":18.7},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":2.8},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":20.2},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":53.7},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":73.2},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":45},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":18.8},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":13.3},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":79},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0.27},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":0.65999999999999992},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":0.74},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":90.9},"Bungkil inti sawit",0,4.689832073035312,20,"BETN",0,{"$f":"SUMPRODUCT(BETN,KomposisiRansum)/100","v":57.380042838591841},100,5.1593312134601881,5.1593312134601881]
[null,7,null,"Ampas kecap",null,{"$f":"_xlfn.IFNA(VLOOKUP($D14,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":2500},null,null,null,-2.2204460492503131E-16,null,-7.1971499077361509E-16,null,null,null,"NDF",null,"%",null,null,null,35.000000000000021,null,35,null,null,7,{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"Ampas kecap"},9398.4962406015056,{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":73.400000000000006},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":14.2},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":23.5},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":24.2},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":16},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":22.1},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":87.2},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0.88200000000000001},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":0.14099999999999999},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":26.599999999999994},"Ampas kecap",0,-2.2204460492503131E-16,100,"NDF",0,{"$f":"SUMPRODUCT(NDF,KomposisiRansum)/100","v":35.000000000000021},35,-8.3475415385350136E-16,-8.3475415385350136E-16]
[null,8,null,"Kulit kopi",null,{"$f":"_xlfn.IFNA(VLOOKUP($D15,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":1200},null,null,null,5,null,6.1584855120959228,null,5,null,"ADF",null,"%",null,null,null,17.479901759459068,null,null,null,null,8,{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"Kulit kopi"},1714.2857142857142,{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":30},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":11.28},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":9.94},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":1.97},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":18.170000000000002},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":58.6},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":50.6},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0.68},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":0.2},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":70},"Kulit kopi",0,5,5,"ADF",0,{"$f":"SUMPRODUCT(ADF,KomposisiRansum)/100","v":17.479901759459068},100,7.1428571428571432,7.1428571428571432]
[null,9,null,"Kulit kacang",null,{"$f":"_xlfn.IFNA(VLOOKUP($D16,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":350},null,null,null,5,null,4.7062662210340021,null,5,null,"GE",null,"MJ/kg",null,null,null,14.258637793358327,null,null,null,null,9,{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"Kulit kacang"},382.09606986899564,{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":8.4000000000000057},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":5.2},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":7},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":2},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":65.900000000000006},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":19.899999999999991},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":66.400000000000006},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":56.4},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":19.8},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":3.4},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":48},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0.24},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":6.9999999999999993E-2},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":0.69000000000000006},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0.01},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":91.6},"Kulit kacang",0,5,5,"GE",0,{"$f":"SUMPRODUCT(GE,KomposisiRansum)/100","v":14.258637793358327},100,5.4585152838427948,5.4585152838427948]
[null,10,null,"Molases",null,{"$f":"_xlfn.IFNA(VLOOKUP($D17,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":3500},null,null,null,0,null,0,null,null,null,"DE",null,"MJ/kg",null,null,null,8.5186917397827226,null,null,null,null,10,{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"Molases"},4794.5205479452052,{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":27},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":14.6},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":5.5},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":1},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":0.1},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":78.8},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":0.8},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":0.5},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":14.7},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":11.3},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":70.7},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0.91999999999999993},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":6.9999999999999993E-2},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":5.0999999999999996},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0.24},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":73},"Molases",0,0,100,"DE",0,{"$f":"SUMPRODUCT(DE,KomposisiRansum)/100","v":8.5186917397827226},100,0,0]
[null,11,null,"Garam",null,{"$f":"_xlfn.IFNA(VLOOKUP($D18,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":2000},null,0.5,null,0.5,null,0.45378314299654166,null,0.5,null,"TDN",null,"%",null,68,null,69.158337658805209,null,null,null,null,11,{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"Garam"},2105.2631578947367,{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":5},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":99},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":60.6},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":39.4},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":95},"Garam",0.5,0.5,0.5,"TDN",68,{"$f":"SUMPRODUCT(TDN,KomposisiRansum)/100","v":69.158337658805209},100,0.52631578947368418,0.52631578947368418]
[null,12,null,"Kapur",null,{"$f":"_xlfn.IFNA(VLOOKUP($D19,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":1500},null,null,null,2.903856002407764,null,2.6354418071639363,null,null,null,"Kalsium",null,"%",null,0.6,null,1.2000000000000002,null,1.2,null,null,12,{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"Kapur"},1578.9473684210527,{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":5},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":99},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":36},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":95},"Kapur",0,2.903856002407764,100,"Kalsium",0.6,{"$f":"SUMPRODUCT(Ca,KomposisiRansum)/100","v":1.2000000000000002},1.2,3.0566905288502779,3.0566905288502779]
[null,13,null,"DCP",null,{"$f":"_xlfn.IFNA(VLOOKUP($D20,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":10000},null,null,null,-1.7347234759768071E-18,null,-1.5743765423172825E-18,null,null,null,"Phosphor",null,"%",null,0.4,null,0.68855861404383678,null,0.8,null,null,13,{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"DCP"},10526.315789473685,{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":5},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":99},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":23},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":17},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":95},"DCP",0,-1.7347234759768071E-18,100,"Phosphor",0.4,{"$f":"SUMPRODUCT(P,KomposisiRansum)/100","v":0.68855861404383678},0.8,-1.8260247115545337E-18,-1.8260247115545337E-18]
[null,14,null,"-",null,{"$f":"_xlfn.IFNA(VLOOKUP($D21,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":9999999999},null,null,null,0,null,0,null,null,null,"Kalium",null,"%",null,null,null,1.3715841556563309,null,null,null,null,14,{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"-"},9999999999,{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":100},"-",0,0,100,"Kalium",0,{"$f":"SUMPRODUCT(K,KomposisiRansum)/100","v":1.3715841556563309},100,0,0]
[null,15,null,"-",null,{"$f":"_xlfn.IFNA(VLOOKUP($D22,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":9999999999},null,null,null,0,null,0,null,null,null,"Natrium",null,"%",null,null,null,0.21497722188551729,null,null,null,null,15,{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"-"},9999999999,{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":100},"-",0,0,100,"Natrium",0,{"$f":"SUMPRODUCT(Na,KomposisiRansum)/100","v":0.21497722188551729},100,0,0]
[]
[null,null,null,"Harga Ransum (Rp/kg BK)",null,{"$f":"IF(HargaRansum<10000,HargaRansum,\"Ërror\")","v":3267.95828554646},null,null,null,{"$f":"SUM(KomposisiRansum)","v":99.999999999999972},null,{"$f":"(SUM(L8:L22))","v":99.999999999999972},null,null,null,"Click to formulate >>",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(KomposisiRansum*Harga)/100","v":3267.95828554646},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(SUM(BB8:BB22))","v":115.98398873924131},{"$f":"(SUM(BC8:BC22))","v":115.98398873924131}]
[null,null,null,"Harga Ransum (Rp/kg segar)",null,{"$f":"SUMPRODUCT(L8:L22,F8:F22)/100","v":2817.5943257940385},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2019-09-03T19:07:03.740"}]
[null," (c) 2019 Department of Nutrition and Feed Technology - IPB University"]

{"sheet":"TRIAL & ERROR","index":6,"n_rows":26,"n_cols":55,"rows_kept":26,"cut":false,"hidden":false,"merged":[[4,15,4,23],[23,15,24,15],[25,1,25,13],[23,21,24,23]]}
[]
[null,null,null,"FORSUM for Ruminant ver 4.0++"]
[null,null,null," (c) 2019 Department of Nutrition and Feed Technology - IPB University",null,null,null,null,null,null,null,null,null,null,null,"Nama Ransum",":","Konsentrat Sapi Perah"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Formulator",":","Idat G. Permana"]
[null,"Tabel 1. Komposisi Ransum (Trial & Errror)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Tabel 2. Kandungan Nutrien Ransum (% DM)",null,null,null,null,null,null,null,null,null,null,"Tabel 3. Perhitungan Ransum (Jangan Dihapus)"]
[" ","No",null,"Bahan Pakan",null,"Harga",null,"Min",null,"%BK",null,"%AsFeed",null,"Max",null,"Nutrien",null,"Unit",null,"Min",null,"Nutrien",null,"Max",null,null,"No","Ingredient","Harga BK","KA","Abu","PK","LK","SK","BETN","NDF","ADF","GE","DE","TDN","Ca","P","K","Na","BK","Bahan Pakan","Min","Komposisi Ransum","Max","Nutrien","Min","Nutrient","Max","%AsFeed","%AsFeed"]
[]
[null,1,null,"Rumput gajah",null,{"$f":"_xlfn.IFNA(VLOOKUP($D8,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":230},null,null,null,60,null,{"$f":"BB8/($BB$24/100)","v":88.315926892950401},null,null,null,"Kadar Air",null,"%",null,null,null,{"$f":"AZ8","v":53.18},null,null,null,null,1,{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"Rumput gajah"},{"$f":"IF(F8>0,F8*100/AS8,99999999)","v":1284.916201117318},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":82.1},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":13.8},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":9.6999999999999993},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":2},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":36.1},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":38.4},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":71.5},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":42.5},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":17.399999999999999},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":10.199999999999999},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":58},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0.36},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":0.28999999999999998},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":2.9},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0.03},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":17.900000000000006},{"$f":"AB8","v":"Rumput gajah"},{"$f":"IF(H8>0,H8,0)","v":0},{"$f":"J8","v":60},{"$f":"IF(N8>0,N8,100)","v":100},{"$f":"P8","v":"Kadar Air"},{"$f":"IF(T8>0,T8,0)","v":0},{"$f":"SUMPRODUCT(KadarAir,KomposisiRansum)/100","v":53.18},{"$f":"IF(X8>0,X8,100)","v":100},{"$f":"IFERROR(BC8,0)","v":335.19553072625689},{"$f":"100/AS8*J8","v":335.19553072625689}]
[null,2,null,"Dedak padi",null,{"$f":"_xlfn.IFNA(VLOOKUP($D9,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":2800},null,null,null,40,null,{"$f":"BB9/($BB$24/100)","v":11.684073107049612},null,null,null,"Abu",null,"%",null,null,null,{"$f":"AZ9","v":13.24},null,null,null,null,2,{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"Dedak padi"},{"$f":"IF(F9>0,F9*100/AS9,99999999)","v":3104.2128603104211},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":9.7999999999999972},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":12.4},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":10},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":14.4},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":16.3},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":44.2},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":34.4},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":19.600000000000001},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":20.2},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":10},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":67.900000000000006},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":6.9999999999999993E-2},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":1.3800000000000001},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":1.23},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0.02},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":90.2},"Dedak padi",{"$f":"IF(H9>0,H9,0)","v":0},{"$f":"J9","v":40},{"$f":"IF(N9>0,N9,100)","v":100},{"$f":"P9","v":"Abu"},{"$f":"IF(T9>0,T9,0)","v":0},{"$f":"SUMPRODUCT(Abu,KomposisiRansum)/100","v":13.24},{"$f":"IF(X9>0,X9,100)","v":100},{"$f":"IFERROR(BC9,0)","v":44.345898004434588},{"$f":"100/AS9*J9","v":44.345898004434588}]
[null,3,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP($D10,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":0},null,null,null,0,null,0,null,null,null,"Protein Kasar",null,"%",null,null,null,9.82,null,null,null,null,3,{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":0},99999999,{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":0},0,0,0,100,"Protein Kasar",0,{"$f":"SUMPRODUCT(PK,KomposisiRansum)/100","v":9.82},100,0,{"$error":"#DIV/0!"}]
[null,4,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP($D11,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":0},null,null,null,0,null,0,null,null,null,"Lemak Kasar",null,"%",null,null,null,6.96,null,null,null,null,4,{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":0},99999999,{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":0},0,0,0,100,"Lemak Kasar",0,{"$f":"SUMPRODUCT(LK,KomposisiRansum)/100","v":6.96},100,0,{"$error":"#DIV/0!"}]
[null,5,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP($D12,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":0},null,null,null,0,null,0,null,null,null,"Serat Kasar",null,"%",null,null,null,28.18,null,null,null,null,5,{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":0},99999999,{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":0},0,0,0,100,"Serat Kasar",0,{"$f":"SUMPRODUCT(SK,KomposisiRansum)/100","v":28.18},100,0,{"$error":"#DIV/0!"}]
[null,6,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP($D13,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":0},null,null,null,0,null,0,null,null,null,"BETN",null,"%",null,null,null,40.72,null,null,null,null,6,{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":0},99999999,{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":0},0,0,0,100,"BETN",0,{"$f":"SUMPRODUCT(BETN,KomposisiRansum)/100","v":40.72},100,0,{"$error":"#DIV/0!"}]
[null,7,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP($D14,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":0},null,null,null,0,null,0,null,null,null,"NDF",null,"%",null,null,null,56.66,null,null,null,null,7,{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":0},99999999,{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":0},0,0,0,100,"NDF",0,{"$f":"SUMPRODUCT(NDF,KomposisiRansum)/100","v":56.66},100,0,{"$error":"#DIV/0!"}]
[null,8,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP($D15,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":0},null,null,null,0,null,0,null,null,null,"ADF",null,"%",null,null,null,33.340000000000003,null,null,null,null,8,{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":0},99999999,{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":0},0,0,0,100,"ADF",0,{"$f":"SUMPRODUCT(ADF,KomposisiRansum)/100","v":33.340000000000003},100,0,{"$error":"#DIV/0!"}]
[null,9,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP($D16,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":0},null,null,null,0,null,0,null,null,null,"GE",null,"MJ/kg",null,null,null,18.52,null,null,null,null,9,{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":0},99999999,{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":0},0,0,0,100,"GE",0,{"$f":"SUMPRODUCT(GE,KomposisiRansum)/100","v":18.52},100,0,{"$error":"#DIV/0!"}]
[null,10,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP($D17,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":0},null,null,null,0,null,0,null,null,null,"DE",null,"MJ/kg",null,null,null,10.119999999999999,null,null,null,null,10,{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":0},99999999,{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":0},0,0,0,100,"DE",0,{"$f":"SUMPRODUCT(DE,KomposisiRansum)/100","v":10.119999999999999},100,0,{"$error":"#DIV/0!"}]
[null,11,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP($D18,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":0},null,null,null,0,null,0,null,null,null,"TDN",null,"%",null,null,null,61.96,null,null,null,null,11,{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":0},99999999,{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":0},0,0,0,100,"TDN",0,{"$f":"SUMPRODUCT(TDN,KomposisiRansum)/100","v":61.96},100,0,{"$error":"#DIV/0!"}]
[null,12,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP($D19,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":0},null,null,null,0,null,0,null,null,null,"Kalsium",null,"%",null,null,null,0.24399999999999999,null,null,null,null,12,{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":0},99999999,{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":0},0,0,0,100,"Kalsium",0,{"$f":"SUMPRODUCT(Ca,KomposisiRansum)/100","v":0.24399999999999999},100,0,{"$error":"#DIV/0!"}]
[null,13,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP($D20,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":0},null,null,null,0,null,0,null,null,null,"Phosphor",null,"%",null,null,null,0.72599999999999998,null,null,null,null,13,{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":0},99999999,{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":0},0,0,0,100,"Phosphor",0,{"$f":"SUMPRODUCT(P,KomposisiRansum)/100","v":0.72599999999999998},100,0,{"$error":"#DIV/0!"}]
[null,14,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP($D21,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":0},null,null,null,0,null,0,null,null,null,"Kalium",null,"%",null,null,null,2.2319999999999998,null,null,null,null,14,{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":0},99999999,{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":0},0,0,0,100,"Kalium",0,{"$f":"SUMPRODUCT(K,KomposisiRansum)/100","v":2.2319999999999998},100,0,{"$error":"#DIV/0!"}]
[null,15,null,null,null,{"$f":"_xlfn.IFNA(VLOOKUP($D22,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":0},null,null,null,0,null,0,null,null,null,"Natrium",null,"%",null,null,null,2.5999999999999995E-2,null,null,null,null,15,{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":0},99999999,{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":0},0,0,0,100,"Natrium",0,{"$f":"SUMPRODUCT(Na,KomposisiRansum)/100","v":2.5999999999999995E-2},100,0,{"$error":"#DIV/0!"}]
[]
[null,null,null,"Harga Ransum (Rp/kg BK)",null,{"$f":"IF(HargaRansum<10000,HargaRansum,\"Ërror\")","v":2012.6348647945592},null,null,null,{"$f":"SUM(KomposisiRansum)","v":100},null,{"$f":"(SUM(L8:L22))","v":100.00000000000001},null,null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2019-09-03T19:07:03.740"},null,null,null,null,null,null,{"$f":"SUMPRODUCT(KomposisiRansum*Harga)/100","v":2012.6348647945592},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(SUM(BB8:BB22))","v":379.54142873069145},{"$f":"(SUM(BC8:BC22))","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Harga Ransum (Rp/kg segar)",null,{"$f":"SUMPRODUCT(L8:L22,F8:F22)/100","v":530.28067885117503}]
[null," (c) 2019 Department of Nutrition and Feed Technology - IPB University"]

{"sheet":"CONTACT","index":7,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"         FORSUM for Ruminant ver 4.0++"]
[null,"                     (c) 2019 Department of Nutrition and Feed Technology - IPB University"]
[]
[null,"About FORSUM"]
[null,"FORSUM for Ruminant is a simple ration formulation program using Excel Solver. The ration formulated from FORSUM is the least cost ration. Solver is an application based on Linear Programming (LP), which is a method to minimize costs."]
[]
[]
[null,"CONTACT"]
[null,"Dr.Ir. Idat Galih Permana, MSc."]
[null,"Department of Nutrition and Feed Technology, Faculty of Animal Science, IPB University"]
[null,"Jl. Agatis Kampus Darmaga, 16689 Bogor"]
[null,"http://permana.staff.ipb.ac.id"]
[null,"Phone: +62.81380263993"]
[null,"Email: permana@apps.ipb.ac.id"]

{"sheet":"BACKUP","index":8,"n_rows":26,"n_cols":55,"rows_kept":26,"cut":false,"hidden":false,"merged":[[4,15,4,23],[23,15,24,15],[24,21,24,23],[25,1,25,13]]}
[]
[null,null,null,"FORSUM for Ruminant ver 4.0++"]
[null,null,null," (c) 2019 Department of Nutrition and Feed Technology - IPB University",null,null,null,null,null,null,null,null,null,null,null,"Nama Ransum",":","Konsentrat Sapi Perah"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Formulator",":","Idat G. Permana"]
[null,"Tabel 1. Komposisi Ransum (Least Cost Ration)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Tabel 2. Kandungan Nutrien Ransum (% DM)",null,null,null,null,null,null,null,null,null,null,"Tabel 3. Perhitungan Ransum (Jangan Dihapus)"]
[" ","No",null,"Bahan Pakan",null,"Harga",null,"Min",null,"%BK",null,"%AsFeed",null,"Max",null,"Nutrien",null,"Unit",null,"Min",null,"Nutrien",null,"Max",null,null,"No","Ingredient","Harga BK","KA","Abu","PK","LK","SK","BETN","NDF","ADF","GE","DE","TDN","Ca","P","K","Na","BK","Bahan Pakan","Min","Komposisi Ransum","Max","Nutrien","Min","Nutrient","Max","%AsFeed","%AsFeed"]
[]
[null,1,null,"Jagung",null,{"$f":"_xlfn.IFNA(VLOOKUP($D8,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":4500},null,5,null,5.0000000000000178,null,{"$f":"BB8/($BB$24/100)","v":4.9952953168796768},null,null,null,"Kadar Air",null,"%",null,null,null,{"$f":"AZ8","v":13.393442769954639},null,null,null,null,1,{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"Jagung"},{"$f":"IF(F8>0,F8*100/AS8,99999999)","v":5214.3684820393973},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":13.700000000000003},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":1.4},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":9.4},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":4.3},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":2.5},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":82.4},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":12.2},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":3},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":18.7},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":12},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":80.8},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0.05},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":0.3},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":0.39},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D8,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":86.3},{"$f":"AB8","v":"Jagung"},{"$f":"IF(H8>0,H8,0)","v":5},{"$f":"J8","v":5.0000000000000178},{"$f":"IF(N8>0,N8,100)","v":100},{"$f":"P8","v":"Kadar Air"},{"$f":"IF(T8>0,T8,0)","v":0},{"$f":"SUMPRODUCT(KadarAir,KomposisiRansum)/100","v":13.393442769954639},{"$f":"IF(X8>0,X8,100)","v":100},{"$f":"IFERROR(BC8,0)","v":5.7937427578215734},{"$f":"100/AS8*J8","v":5.7937427578215734}]
[null,2,null,"Dedak padi",null,{"$f":"_xlfn.IFNA(VLOOKUP($D9,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":2800},null,null,null,15,null,{"$f":"BB9/($BB$24/100)","v":14.337937445012679},null,15,null,"Abu",null,"%",null,null,null,{"$f":"AZ9","v":9.5380122072982108},null,12,null,null,2,{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"Dedak padi"},{"$f":"IF(F9>0,F9*100/AS9,99999999)","v":3104.2128603104211},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":9.7999999999999972},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":12.4},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":10},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":14.4},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":16.3},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":44.2},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":34.4},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":19.600000000000001},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":20.2},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":10},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":67.900000000000006},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":6.9999999999999993E-2},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":1.3800000000000001},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":1.23},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0.02},{"$f":"_xlfn.IFNA(VLOOKUP(D9,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":90.2},"Dedak padi",{"$f":"IF(H9>0,H9,0)","v":0},{"$f":"J9","v":15},{"$f":"IF(N9>0,N9,100)","v":15},{"$f":"P9","v":"Abu"},{"$f":"IF(T9>0,T9,0)","v":0},{"$f":"SUMPRODUCT(Abu,KomposisiRansum)/100","v":9.5380122072982108},{"$f":"IF(X9>0,X9,100)","v":12},{"$f":"IFERROR(BC9,0)","v":16.62971175166297},{"$f":"100/AS9*J9","v":16.62971175166297}]
[null,3,null,"Pollard",null,{"$f":"_xlfn.IFNA(VLOOKUP($D10,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":3600},null,null,null,24.772218855172945,null,24.549780608146303,null,null,null,"Protein Kasar",null,"%",null,13,null,13.000000000000005,null,null,null,null,3,{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"Pollard"},4137.9310344827591,{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":13},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":5.6},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":17.3},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":3.9},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":10.4},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":62.800000000000004},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":45.2},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":13.4},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":18.899999999999999},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":11},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":69.2},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0.13999999999999999},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":1.1099999999999999},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":1.3699999999999999},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0.01},{"$f":"_xlfn.IFNA(VLOOKUP(D10,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":87},"Pollard",0,24.772218855172945,100,"Protein Kasar",13,{"$f":"SUMPRODUCT(PK,KomposisiRansum)/100","v":13.000000000000005},100,28.473814776060856,28.473814776060856]
[null,4,null,"Onggok kering",null,{"$f":"_xlfn.IFNA(VLOOKUP($D11,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":2400},null,null,null,17.134093069383923,null,18.512291917667376,null,null,null,"Lemak Kasar",null,"%",null,null,null,4.2864462949415385,null,7,null,null,4,{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"Onggok kering"},3007.5187969924814,{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":20.200000000000003},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":2.4},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":1.87},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":0.32400000000000001},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":8.9},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":85.5},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":78.3},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0.2},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":0.1},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D11,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":79.8},"Onggok kering",0,17.134093069383923,100,"Lemak Kasar",0,{"$f":"SUMPRODUCT(LK,KomposisiRansum)/100","v":4.2864462949415385},7,21.471294573162812,21.471294573162812]
[null,5,null,"Bungkil kelapa",null,{"$f":"_xlfn.IFNA(VLOOKUP($D12,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":3100},null,null,null,20,null,19.202404714775703,null,20,null,"Serat Kasar",null,"%",null,null,null,15.182091122866289,null,null,null,null,5,{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"Bungkil kelapa"},3452.1158129175947,{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":10.200000000000003},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":7},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":23.5},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":2.8},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":16.8},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":49.900000000000006},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":56.4},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":30.7},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":18.7},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":14.5},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":78.7},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":6.9999999999999993E-2},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":0.65},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":2.2800000000000002},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0.06},{"$f":"_xlfn.IFNA(VLOOKUP(D12,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":89.8},"Bungkil kelapa",0,20,20,"Serat Kasar",0,{"$f":"SUMPRODUCT(SK,KomposisiRansum)/100","v":15.182091122866289},100,22.271714922048996,22.271714922048996]
[null,6,null,"Bungkil inti sawit",null,{"$f":"_xlfn.IFNA(VLOOKUP($D13,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":2900},null,null,null,4.689832073035312,null,4.4483133142278382,null,20,null,"BETN",null,"%",null,null,null,57.380042838591841,null,null,null,null,6,{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"Bungkil inti sawit"},3190.3190319031901,{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":9.0999999999999943},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":4.5999999999999996},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":18.7},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":2.8},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":20.2},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":53.7},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":73.2},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":45},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":18.8},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":13.3},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":79},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0.27},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":0.65999999999999992},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":0.74},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D13,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":90.9},"Bungkil inti sawit",0,4.689832073035312,20,"BETN",0,{"$f":"SUMPRODUCT(BETN,KomposisiRansum)/100","v":57.380042838591841},100,5.1593312134601881,5.1593312134601881]
[null,7,null,"Ampas kecap",null,{"$f":"_xlfn.IFNA(VLOOKUP($D14,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":2500},null,null,null,-2.2204460492503131E-16,null,-7.1971499077361509E-16,null,null,null,"NDF",null,"%",null,null,null,35.000000000000021,null,35,null,null,7,{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"Ampas kecap"},9398.4962406015056,{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":73.400000000000006},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":14.2},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":23.5},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":24.2},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":16},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":22.1},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":87.2},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0.88200000000000001},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":0.14099999999999999},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D14,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":26.599999999999994},"Ampas kecap",0,-2.2204460492503131E-16,100,"NDF",0,{"$f":"SUMPRODUCT(NDF,KomposisiRansum)/100","v":35.000000000000021},35,-8.3475415385350136E-16,-8.3475415385350136E-16]
[null,8,null,"Kulit kopi",null,{"$f":"_xlfn.IFNA(VLOOKUP($D15,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":1200},null,null,null,5,null,6.1584855120959228,null,5,null,"ADF",null,"%",null,null,null,17.479901759459068,null,null,null,null,8,{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"Kulit kopi"},1714.2857142857142,{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":30},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":11.28},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":9.94},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":1.97},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":18.170000000000002},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":58.6},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":50.6},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0.68},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":0.2},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D15,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":70},"Kulit kopi",0,5,5,"ADF",0,{"$f":"SUMPRODUCT(ADF,KomposisiRansum)/100","v":17.479901759459068},100,7.1428571428571432,7.1428571428571432]
[null,9,null,"Kulit kacang",null,{"$f":"_xlfn.IFNA(VLOOKUP($D16,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":350},null,null,null,5,null,4.7062662210340021,null,5,null,"GE",null,"MJ/kg",null,null,null,14.258637793358327,null,null,null,null,9,{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"Kulit kacang"},382.09606986899564,{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":8.4000000000000057},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":5.2},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":7},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":2},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":65.900000000000006},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":19.899999999999991},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":66.400000000000006},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":56.4},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":19.8},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":3.4},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":48},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0.24},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":6.9999999999999993E-2},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":0.69000000000000006},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0.01},{"$f":"_xlfn.IFNA(VLOOKUP(D16,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":91.6},"Kulit kacang",0,5,5,"GE",0,{"$f":"SUMPRODUCT(GE,KomposisiRansum)/100","v":14.258637793358327},100,5.4585152838427948,5.4585152838427948]
[null,10,null,"Molases",null,{"$f":"_xlfn.IFNA(VLOOKUP($D17,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":3500},null,null,null,0,null,0,null,null,null,"DE",null,"MJ/kg",null,null,null,8.5186917397827226,null,null,null,null,10,{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"Molases"},4794.5205479452052,{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":27},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":14.6},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":5.5},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":1},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":0.1},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":78.8},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":0.8},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":0.5},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":14.7},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":11.3},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":70.7},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0.91999999999999993},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":6.9999999999999993E-2},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":5.0999999999999996},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0.24},{"$f":"_xlfn.IFNA(VLOOKUP(D17,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":73},"Molases",0,0,100,"DE",0,{"$f":"SUMPRODUCT(DE,KomposisiRansum)/100","v":8.5186917397827226},100,0,0]
[null,11,null,"Garam",null,{"$f":"_xlfn.IFNA(VLOOKUP($D18,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":2000},null,0.5,null,0.5,null,0.45378314299654166,null,0.5,null,"TDN",null,"%",null,68,null,69.158337658805209,null,null,null,null,11,{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"Garam"},2105.2631578947367,{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":5},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":99},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":60.6},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":39.4},{"$f":"_xlfn.IFNA(VLOOKUP(D18,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":95},"Garam",0.5,0.5,0.5,"TDN",68,{"$f":"SUMPRODUCT(TDN,KomposisiRansum)/100","v":69.158337658805209},100,0.52631578947368418,0.52631578947368418]
[null,12,null,"Kapur",null,{"$f":"_xlfn.IFNA(VLOOKUP($D19,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":1500},null,null,null,2.903856002407764,null,2.6354418071639363,null,null,null,"Kalsium",null,"%",null,0.6,null,1.2000000000000002,null,1.2,null,null,12,{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"Kapur"},1578.9473684210527,{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":5},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":99},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":36},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D19,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":95},"Kapur",0,2.903856002407764,100,"Kalsium",0.6,{"$f":"SUMPRODUCT(Ca,KomposisiRansum)/100","v":1.2000000000000002},1.2,3.0566905288502779,3.0566905288502779]
[null,13,null,"DCP",null,{"$f":"_xlfn.IFNA(VLOOKUP($D20,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":10000},null,null,null,-1.7347234759768071E-18,null,-1.5743765423172825E-18,null,null,null,"Phosphor",null,"%",null,0.4,null,0.68855861404383678,null,0.8,null,null,13,{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"DCP"},10526.315789473685,{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":5},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":99},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":23},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":17},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D20,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":95},"DCP",0,-1.7347234759768071E-18,100,"Phosphor",0.4,{"$f":"SUMPRODUCT(P,KomposisiRansum)/100","v":0.68855861404383678},0.8,-1.8260247115545337E-18,-1.8260247115545337E-18]
[null,14,null,"-",null,{"$f":"_xlfn.IFNA(VLOOKUP($D21,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":9999999999},null,null,null,0,null,0,null,null,null,"Kalium",null,"%",null,null,null,1.3715841556563309,null,null,null,null,14,{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"-"},9999999999,{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D21,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":100},"-",0,0,100,"Kalium",0,{"$f":"SUMPRODUCT(K,KomposisiRansum)/100","v":1.3715841556563309},100,0,0]
[null,15,null,"-",null,{"$f":"_xlfn.IFNA(VLOOKUP($D22,'BAHAN PAKAN'!$D$7:$Y$106,4,FALSE),0)","v":9999999999},null,null,null,0,null,0,null,null,null,"Natrium",null,"%",null,null,null,0.21497722188551729,null,null,null,null,15,{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,1,FALSE),0)","v":"-"},9999999999,{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,6,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,8,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,9,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,10,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,11,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,12,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,13,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,14,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,15,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,16,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,17,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,18,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,19,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,20,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,21,FALSE),0)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(D22,'BAHAN PAKAN'!$D$7:$Y$106,22,FALSE),0)","v":100},"-",0,0,100,"Natrium",0,{"$f":"SUMPRODUCT(Na,KomposisiRansum)/100","v":0.21497722188551729},100,0,0]
[]
[null,null,null,"Harga Ransum (Rp/kg BK)",null,{"$f":"IF(HargaRansum<10000,HargaRansum,\"Ërror\")","v":3267.95828554646},null,null,null,{"$f":"SUM(KomposisiRansum)","v":99.999999999999972},null,{"$f":"(SUM(L8:L22))","v":99.999999999999972},null,null,null,"Click to formulate >>",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(KomposisiRansum*Harga)/100","v":3267.95828554646},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(SUM(BB8:BB22))","v":115.98398873924131},{"$f":"(SUM(BC8:BC22))","v":115.98398873924131}]
[null,null,null,"Harga Ransum (Rp/kg segar)",null,{"$f":"SUMPRODUCT(L8:L22,F8:F22)/100","v":2817.5943257940385},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2019-09-03T19:07:03.740"}]
[null," (c) 2019 Department of Nutrition and Feed Technology - IPB University"]